if exists (select 1
            from  sysobjects
           where  id = object_id('bd_kq_work_calendar_detail')
            and   type = 'U')
   drop table bd_kq_work_calendar_detail
go

/*==============================================================*/
/* Table: bd_kq_work_calendar_detail                            */
/*==============================================================*/
create table bd_kq_work_calendar_detail (
   id                   int                  identity,
   parent_id            int                  not null,
   work_date            date                 not null,
   work_year            int                  not null default 0,
   work_month           int                  not null default 0,
   is_weekend           int                  not null default 0,
   is_statutory         int                  not null default 0,
   shift_id             int                  not null default 0,
   constraint PK_BD_KQ_WORK_CALENDAR_DETAIL primary key (id)
)
go
